﻿INSERT  INTO dbo.tHolidays
        ( holidayId ,
          holidayName ,
          description ,
          holidayMonth ,
          holidayDate ,
          holidayTypeId ,
          countryId
        )
VALUES  ( 19 , -- holidayId - int
          'Good Friday' , -- holidayName - varchar(200)
          NULL , -- description - varchar(500)
          4 , -- holidayMonth - int
          18 , -- holidayDate - int
          ( SELECT  THT.holidayTypeId
            FROM    dbo.tHolidayType AS THT
            WHERE   THT.typeName = 'Christian Holiday'
          ) , -- holidayTypeId - int
          ( SELECT  TC.CountryID
            FROM    dbo.tCountry AS TC
            WHERE   TC.ThreeLetterISOCode = 'USA'
          ) -- countryId - int
        )

INSERT  INTO dbo.tHolidays
        ( holidayId ,
          holidayName ,
          description ,
          holidayMonth ,
          holidayDate ,
          holidayTypeId ,
          countryId
        )
VALUES  ( 20 , -- holidayId - int
          'Easter Monday' , -- holidayName - varchar(200)
          NULL , -- description - varchar(500)
          4 , -- holidayMonth - int
          21 , -- holidayDate - int
          ( SELECT  THT.holidayTypeId
            FROM    dbo.tHolidayType AS THT
            WHERE   THT.typeName = 'Christian Holiday'
          ) , -- holidayTypeId - int
          ( SELECT  TC.CountryID
            FROM    dbo.tCountry AS TC
            WHERE   TC.ThreeLetterISOCode = 'USA'
          ) -- countryId - int
        )